USE [sample]
GO
/****** Object:  StoredProcedure [dbo].[sp_TIMECARDS]    Script Date: 10/09/2012 17:54:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Venky Mokka
-- Create date:	10/09/2012 12:42:08
-- Description:	Our first Sp
-- =============================================
ALTER procedure [dbo].[sp_TIMECARDS]
(@ID int=0 output,@AUTHOR varchar(50),@HOURS int,@DATE varchar(50),@action varchar)

as 
SET NOCOUNT ON  
declare @Error int
BEGIN TRAN
set @Error=@@ERROR
begin
if(@action='i')
begin
insert into TIMECARDS(AUTHOR,HOURS,DATE)values (@AUTHOR,@HOURS,@DATE)
 SET @ID = @@IDENTITY;
end
else if(@action='u')
begin
update TIMECARDS set AUTHOR=@AUTHOR,HOURS=@HOURS,DATE=@DATE where ID=@ID
end
else if(@action='d')
begin
delete from TIMECARDS where ID=@ID
end
else if(@action='s')
begin
select * from TIMECARDS
end
end
COMMIT TRAN
RETURN @@ERROR

  


  

